﻿

--修改菜单
CREATE PROCEDURE [dbo].[proc_App_Menu_Delete]
	(
		@ID INT,			
		@MId varchar(100)
	)
AS
	DECLARE @coun INT
	SET @coun=(SELECT COUNT(0) FROM App_Menu WHERE ID=@ID AND MID=@MId)
	IF(@coun>0)
	BEGIN
		DELETE FROM [App_Menu] WHERE SUBSTRING(MID,1,len(@MId))=@MId 
	END
	RETURN


